package com.itchu.system.mapper;


import com.itchu.system.domain.Song;
import org.apache.ibatis.annotations.Param;
import com.itchu.system.common.BaseMapper;

import java.util.List;

public interface SongMapper extends BaseMapper<Song> {

    //删除歌曲-风格中间表的记录
    void delSongIdAndCategoryIdBySid(Long sid);

    //向中间表添加记录
    void addSongIdAndCategoryId(@Param("sid") Long sid, @Param("cids") List<Long> cids);

    //飙升榜
    List<Song> findSoar();

    //人气榜
    List<Song> findPopularity();

    //收藏榜
    List<Song> findFavorite();


    List<Song> findSonsBySnameAndSiname(@Param("name") String name);
}
